package com.cy.detectsys.mapper;

import com.cy.detectsys.entity.TcTask;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
* @author admin
* @description 针对表【tc_task】的数据库操作Mapper
* @createDate 2024-05-08 01:58:26
* @Entity com.cy.detectsys.entity.TcTask
*/
public interface TcTaskMapper extends BaseMapper<TcTask> {


    @Select("select id from tc_task where tc_tack_num = #{taskNum} limit 1")
    Integer selectTaskIdByTaskNum(String taskNum);

    @Update("UPDATE `tc_task` \n" +
            "SET STATUS = '已完成' \n" +
            "WHERE\n" +
            "\ttc_tack_num = #{taskNum}")
    void updateByTaskNum(String taskNum);
}




